Overview

Dataset statistics

Number of variables72
Number of observations837766
Missing cells43832259
Missing cells (%)72.7%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory460.2 MiB
Average record size in memory576.0 B

Variable types

CAT31
BOOL22
NUM11
UNSUPPORTED8

Reproduction

Analysis started2020-07-05 20:46:27.042288
Analysis finished2020-07-05 20:51:51.733062
Duration5 minutes and 24.69 seconds
Versionpandas-profiling v2.8.0
Command linepandas_profiling --config_file config.yaml [YOUR_FILE.csv]
Download configurationconfig.yaml

Warnings

CRASH_RECORD_ID has a high cardinality: 414426 distinct values High cardinality
RD_NO has a high cardinality: 410659 distinct values High cardinality
CRASH_DATE has a high cardinality: 268332 distinct values High cardinality
MAKE has a high cardinality: 909 distinct values High cardinality
MODEL has a high cardinality: 2143 distinct values High cardinality
LIC_PLATE_STATE has a high cardinality: 52 distinct values High cardinality
TOWED_BY has a high cardinality: 7298 distinct values High cardinality
TOWED_TO has a high cardinality: 7702 distinct values High cardinality
CARRIER_NAME has a high cardinality: 5945 distinct values High cardinality
CARRIER_CITY has a high cardinality: 1443 distinct values High cardinality
VEHICLE_ID is highly correlated with CRASH_UNIT_ID and 1 other fieldsHigh correlation
CRASH_UNIT_ID is highly correlated with VEHICLE_ID and 1 other fieldsHigh correlation
OCCUPANT_CNT is highly correlated with NUM_PASSENGERSHigh correlation
NUM_PASSENGERS is highly correlated with OCCUPANT_CNTHigh correlation
CMV_ID is highly correlated with CRASH_UNIT_ID and 1 other fieldsHigh correlation
NUM_PASSENGERS has 718762 (85.8%) missing values Missing
VEHICLE_ID has 17454 (2.1%) missing values Missing
CMRC_VEH_I has 822260 (98.1%) missing values Missing
MAKE has 17485 (2.1%) missing values Missing
MODEL has 19418 (2.3%) missing values Missing
LIC_PLATE_STATE has 84715 (10.1%) missing values Missing
VEHICLE_YEAR has 148417 (17.7%) missing values Missing
VEHICLE_DEFECT has 17454 (2.1%) missing values Missing
VEHICLE_TYPE has 17454 (2.1%) missing values Missing
VEHICLE_USE has 17454 (2.1%) missing values Missing
TRAVEL_DIRECTION has 17454 (2.1%) missing values Missing
MANEUVER has 17454 (2.1%) missing values Missing
TOWED_I has 749549 (89.5%) missing values Missing
FIRE_I has 837249 (99.9%) missing values Missing
OCCUPANT_CNT has 17454 (2.1%) missing values Missing
EXCEED_SPEED_LIMIT_I has 835407 (99.7%) missing values Missing
TOWED_BY has 773923 (92.4%) missing values Missing
TOWED_TO has 797332 (95.2%) missing values Missing
AREA_00_I has 803547 (95.9%) missing values Missing
AREA_01_I has 621754 (74.2%) missing values Missing
AREA_02_I has 687809 (82.1%) missing values Missing
AREA_03_I has 757701 (90.4%) missing values Missing
AREA_04_I has 751174 (89.7%) missing values Missing
AREA_05_I has 708242 (84.5%) missing values Missing
AREA_06_I has 714831 (85.3%) missing values Missing
AREA_07_I has 734840 (87.7%) missing values Missing
AREA_08_I has 686559 (82.0%) missing values Missing
AREA_09_I has 812559 (97.0%) missing values Missing
AREA_10_I has 800564 (95.6%) missing values Missing
AREA_11_I has 763625 (91.2%) missing values Missing
AREA_12_I has 765460 (91.4%) missing values Missing
AREA_99_I has 751710 (89.7%) missing values Missing
FIRST_CONTACT_POINT has 21456 (2.6%) missing values Missing
CMV_ID has 828732 (98.9%) missing values Missing
USDOT_NO has 832468 (99.4%) missing values Missing
CCMC_NO has 836608 (99.9%) missing values Missing
ILCC_NO has 836909 (99.9%) missing values Missing
COMMERCIAL_SRC has 831185 (99.2%) missing values Missing
GVWR has 832521 (99.4%) missing values Missing
CARRIER_NAME has 829095 (99.0%) missing values Missing
CARRIER_STATE has 829541 (99.0%) missing values Missing
CARRIER_CITY has 829690 (99.0%) missing values Missing
HAZMAT_PLACARDS_I has 837586 (> 99.9%) missing values Missing
HAZMAT_NAME has 837733 (> 99.9%) missing values Missing
UN_NO has 837430 (> 99.9%) missing values Missing
HAZMAT_PRESENT_I has 831130 (99.2%) missing values Missing
HAZMAT_REPORT_I has 831337 (99.2%) missing values Missing
HAZMAT_REPORT_NO has 837766 (100.0%) missing values Missing
MCS_REPORT_I has 831288 (99.2%) missing values Missing
MCS_REPORT_NO has 837761 (> 99.9%) missing values Missing
HAZMAT_VIO_CAUSE_CRASH_I has 831236 (99.2%) missing values Missing
MCS_VIO_CAUSE_CRASH_I has 831330 (99.2%) missing values Missing
IDOT_PERMIT_NO has 837227 (99.9%) missing values Missing
WIDE_LOAD_I has 837692 (> 99.9%) missing values Missing
TRAILER1_WIDTH has 835808 (99.8%) missing values Missing
TRAILER2_WIDTH has 837544 (> 99.9%) missing values Missing
TRAILER1_LENGTH has 836152 (99.8%) missing values Missing
TRAILER2_LENGTH has 837721 (> 99.9%) missing values Missing
TOTAL_VEHICLE_LENGTH has 835813 (99.8%) missing values Missing
AXLE_CNT has 835049 (99.7%) missing values Missing
VEHICLE_CONFIG has 830224 (99.1%) missing values Missing
CARGO_BODY_TYPE has 830540 (99.1%) missing values Missing
LOAD_TYPE has 830854 (99.2%) missing values Missing
HAZMAT_OUT_OF_SERVICE_I has 831529 (99.3%) missing values Missing
MCS_OUT_OF_SERVICE_I has 831353 (99.2%) missing values Missing
HAZMAT_CLASS has 837151 (99.9%) missing values Missing
VEHICLE_YEAR is highly skewed (γ1 = 49.02841634) Skewed
AXLE_CNT is highly skewed (γ1 = 52.12198557) Skewed
CRASH_RECORD_ID is uniformly distributed Uniform
RD_NO is uniformly distributed Uniform
CRASH_UNIT_ID has unique values Unique
USDOT_NO is an unsupported type, check if it needs cleaning or further analysis Unsupported
CCMC_NO is an unsupported type, check if it needs cleaning or further analysis Unsupported
ILCC_NO is an unsupported type, check if it needs cleaning or further analysis Unsupported
GVWR is an unsupported type, check if it needs cleaning or further analysis Unsupported
UN_NO is an unsupported type, check if it needs cleaning or further analysis Unsupported
HAZMAT_REPORT_NO is an unsupported type, check if it needs cleaning or further analysis Unsupported
MCS_REPORT_NO is an unsupported type, check if it needs cleaning or further analysis Unsupported
IDOT_PERMIT_NO is an unsupported type, check if it needs cleaning or further analysis Unsupported
OCCUPANT_CNT has 102317 (12.2%) zeros Zeros

Variables

CRASH_UNIT_ID
Real number (ℝ≥0)

HIGH CORRELATION
UNIQUE

Distinct count837766
Unique (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean450031.11142252135
Minimum2
Maximum910029
Zeros0
Zeros (%)0.0%
Memory size6.4 MiB

Quantile statistics

Minimum2
5-th percentile43754.25
Q1220128.25
median447564.5
Q3678641.75
95-th percentile863177.75
Maximum910029
Range910027
Interquartile range (IQR)458513.5

Descriptive statistics

Standard deviation263542.9848
Coefficient of variation (CV)0.5856105902
Kurtosis-1.208981022
Mean450031.1114
Median Absolute Deviation (MAD)229218.5
Skewness0.0220150255
Sum3.770207641e+11
Variance6.945490482e+10
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
20471< 0.1%
 
6656161< 0.1%
 
6840591< 0.1%
 
6861061< 0.1%
 
6820081< 0.1%
 
6594791< 0.1%
 
6615261< 0.1%
 
6553811< 0.1%
 
6574281< 0.1%
 
6676671< 0.1%
 
Other values (837756)837756> 99.9%
 
ValueCountFrequency (%) 
21< 0.1%
 
31< 0.1%
 
41< 0.1%
 
51< 0.1%
 
61< 0.1%
 
ValueCountFrequency (%) 
9100291< 0.1%
 
9100281< 0.1%
 
9100211< 0.1%
 
9100201< 0.1%
 
9100191< 0.1%
 

CRASH_RECORD_ID
Categorical

HIGH CARDINALITY
UNIFORM

Distinct count414426
Unique (%)49.5%
Missing0
Missing (%)0.0%
Memory size6.4 MiB
e4f07da854d2b7be0c4c0903296e6f1a1f0109ddebca9d5b5dc399ffc698f2118f0f658ad5b1e3559714e0a3e2550720e3cb88e9753ce9a93ca3a20fa553fed7
 
18
fb8d94334f5987710b7aa9cb4b0302f8e4c8f5f6e6d9f50ff0502a143737b3bfe95c37d970bcab190390797ad5c8fb6a9b6909f73186488c9b91267a4b844c65
 
16
d128ebe105ed99a8372e21acc70d596bf4a64b28249e679ba33d4b450db5dba4621aa305e5e3cc8e31cab1beebf75645b34211d4dbbb434e5fb7d142c2569870
 
15
6485b8f4e89d7685abf38d22d3017003234343937ca227e63c5a20b17903a860917a4bbd523f716f1b926d551a25eaedcb61994139ff8fa4acbec2e7550722a4
 
12
c2430f71beeeefd0a59b1c3e56e57c11f0a7ab04d90b1842d3cc726834ee65a94791bc13ef191959200e0ba1e07a9fce38e5b2d834858d3cf816c4c40de29961
 
12
Other values (414421)
837693
ValueCountFrequency (%) 
e4f07da854d2b7be0c4c0903296e6f1a1f0109ddebca9d5b5dc399ffc698f2118f0f658ad5b1e3559714e0a3e2550720e3cb88e9753ce9a93ca3a20fa553fed718< 0.1%
 
fb8d94334f5987710b7aa9cb4b0302f8e4c8f5f6e6d9f50ff0502a143737b3bfe95c37d970bcab190390797ad5c8fb6a9b6909f73186488c9b91267a4b844c6516< 0.1%
 
d128ebe105ed99a8372e21acc70d596bf4a64b28249e679ba33d4b450db5dba4621aa305e5e3cc8e31cab1beebf75645b34211d4dbbb434e5fb7d142c256987015< 0.1%
 
6485b8f4e89d7685abf38d22d3017003234343937ca227e63c5a20b17903a860917a4bbd523f716f1b926d551a25eaedcb61994139ff8fa4acbec2e7550722a412< 0.1%
 
c2430f71beeeefd0a59b1c3e56e57c11f0a7ab04d90b1842d3cc726834ee65a94791bc13ef191959200e0ba1e07a9fce38e5b2d834858d3cf816c4c40de2996112< 0.1%
 
c9ea6db6a3665f9828881fc7c297f4967a76e059aac1622ec859780f626b40ffaf2ee0f78c87f49434ffec3e991ea9d543be0e8d85406a5215c518e76482b49911< 0.1%
 
94ec1a051bc04155dc7b2be57e480b27908bc41b4a2eca60e887a21ab9f648e542e30046af9ef139c7a6720d4ff523403d6ce3c3cc244ec1dad63765c657ad5c11< 0.1%
 
c1af6a8bcc100b6cd5a2c7c43adcdfba9e76a029ed1f7a0235a139a55428d3443a32d3c98c58498243370a230ff9031e42619a524519619f27d69e4cfa2edfee11< 0.1%
 
f4d195b55b5f6541f9e29125d1c1599bf7980fcdfb2ff1b4d99c1a5d2d8faca86bf10824f3071f17cf7e773469bed11ed359b65e83486c8cabecd9276c15185010< 0.1%
 
182f2fe6a3f75b93ca4589a8578548b7e4bdef14cafd1039386386daa3c74c4b0b1f7c7d1d7b3e3db0b27db3ecbe8fa30d4990b197702623b088f2f1bc35793b10< 0.1%
 
Other values (414416)837640> 99.9%
 

Length

Max length128
Median length128
Mean length128
Min length128

RD_NO
Categorical

HIGH CARDINALITY
UNIFORM

Distinct count410659
Unique (%)49.5%
Missing7719
Missing (%)0.9%
Memory size6.4 MiB
JB311558
 
18
JB330122
 
16
JD141706
 
15
JB530190
 
12
JC406074
 
12
Other values (410654)
829974
ValueCountFrequency (%) 
JB31155818< 0.1%
 
JB33012216< 0.1%
 
JD14170615< 0.1%
 
JB53019012< 0.1%
 
JC40607412< 0.1%
 
JD22363311< 0.1%
 
JA55331711< 0.1%
 
JC16470511< 0.1%
 
JA52287210< 0.1%
 
JD10014610< 0.1%
 
Other values (410649)82992199.1%
 
(Missing)77190.9%
 

Length

Max length8
Median length8
Mean length7.95393105
Min length3

CRASH_DATE
Categorical

HIGH CARDINALITY

Distinct count268332
Unique (%)32.0%
Missing0
Missing (%)0.0%
Memory size6.4 MiB
11/10/2017 10:30:00 AM
 
58
11/10/2017 10:00:00 AM
 
41
01/12/2019 02:30:00 PM
 
39
01/12/2019 02:00:00 PM
 
38
01/12/2019 03:00:00 PM
 
37
Other values (268327)
837553
ValueCountFrequency (%) 
11/10/2017 10:30:00 AM58< 0.1%
 
11/10/2017 10:00:00 AM41< 0.1%
 
01/12/2019 02:30:00 PM39< 0.1%
 
01/12/2019 02:00:00 PM38< 0.1%
 
01/12/2019 03:00:00 PM37< 0.1%
 
02/26/2020 07:45:00 AM35< 0.1%
 
02/26/2020 08:00:00 AM32< 0.1%
 
09/04/2018 08:00:00 AM32< 0.1%
 
01/12/2019 04:00:00 PM31< 0.1%
 
10/10/2018 03:30:00 PM31< 0.1%
 
Other values (268322)837392> 99.9%
 

Length

Max length22
Median length22
Mean length22
Min length22

UNIT_NO
Real number (ℝ≥0)

Distinct count19
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1.555990574933812
Minimum0
Maximum18
Zeros11
Zeros (%)< 0.1%
Memory size6.4 MiB

Quantile statistics

Minimum0
5-th percentile1
Q11
median2
Q32
95-th percentile2
Maximum18
Range18
Interquartile range (IQR)1

Descriptive statistics

Standard deviation0.6210063601
Coefficient of variation (CV)0.399106762
Kurtosis10.3017416
Mean1.555990575
Median Absolute Deviation (MAD)1
Skewness1.516570025
Sum1303556
Variance0.3856488993
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
141403849.4%
 
239161546.7%
 
3253463.0%
 
448400.6%
 
512380.1%
 
6386< 0.1%
 
7154< 0.1%
 
861< 0.1%
 
933< 0.1%
 
1018< 0.1%
 
Other values (9)37< 0.1%
 
ValueCountFrequency (%) 
011< 0.1%
 
141403849.4%
 
239161546.7%
 
3253463.0%
 
448400.6%
 
ValueCountFrequency (%) 
181< 0.1%
 
171< 0.1%
 
162< 0.1%
 
153< 0.1%
 
143< 0.1%
 

UNIT_TYPE
Categorical

Distinct count9
Unique (%)< 0.1%
Missing11
Missing (%)< 0.1%
Memory size6.4 MiB
DRIVER
709212
PARKED
 
103314
PEDESTRIAN
 
10564
DRIVERLESS
 
7667
BICYCLE
 
6044
Other values (4)
 
954
ValueCountFrequency (%) 
DRIVER70921284.7%
 
PARKED10331412.3%
 
PEDESTRIAN105641.3%
 
DRIVERLESS76670.9%
 
BICYCLE60440.7%
 
NON-MOTOR VEHICLE7590.1%
 
NON-CONTACT VEHICLE161< 0.1%
 
DISABLED VEHICLE29< 0.1%
 
EQUESTRIAN5< 0.1%
 
(Missing)11< 0.1%
 

Length

Max length19
Median length6
Mean length6.107054953
Min length3

NUM_PASSENGERS
Real number (ℝ≥0)

HIGH CORRELATION
MISSING

Distinct count40
Unique (%)< 0.1%
Missing718762
Missing (%)85.8%
Infinite0
Infinite (%)0.0%
Mean1.4887650835266042
Minimum1.0
Maximum59.0
Zeros0
Zeros (%)0.0%
Memory size6.4 MiB

Quantile statistics

Minimum1
5-th percentile1
Q11
median1
Q32
95-th percentile3
Maximum59
Range58
Interquartile range (IQR)1

Descriptive statistics

Standard deviation1.114858585
Coefficient of variation (CV)0.7488478859
Kurtosis296.1777592
Mean1.488765084
Median Absolute Deviation (MAD)0
Skewness10.89489652
Sum177169
Variance1.242909665
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1831899.9%
 
2225112.7%
 
388801.1%
 
429130.3%
 
57940.1%
 
6301< 0.1%
 
7124< 0.1%
 
866< 0.1%
 
1042< 0.1%
 
936< 0.1%
 
Other values (30)148< 0.1%
 
(Missing)71876285.8%
 
ValueCountFrequency (%) 
1831899.9%
 
2225112.7%
 
388801.1%
 
429130.3%
 
57940.1%
 
ValueCountFrequency (%) 
591< 0.1%
 
461< 0.1%
 
432< 0.1%
 
421< 0.1%
 
402< 0.1%
 

VEHICLE_ID
Real number (ℝ≥0)

HIGH CORRELATION
MISSING

Distinct count820312
Unique (%)100.0%
Missing17454
Missing (%)2.1%
Infinite0
Infinite (%)0.0%
Mean429604.923371839
Minimum2.0
Maximum862791.0
Zeros0
Zeros (%)0.0%
Memory size6.4 MiB

Quantile statistics

Minimum2
5-th percentile41829.55
Q1214449.75
median428156
Q3645274.25
95-th percentile819137.45
Maximum862791
Range862789
Interquartile range (IQR)430824.5

Descriptive statistics

Standard deviation249060.5324
Coefficient of variation (CV)0.5797431987
Kurtosis-1.197315586
Mean429604.9234
Median Absolute Deviation (MAD)215405.5
Skewness0.008884082005
Sum3.524100739e+11
Variance6.203114882e+10
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1310711< 0.1%
 
3960411< 0.1%
 
3960491< 0.1%
 
247531< 0.1%
 
8339041< 0.1%
 
3960471< 0.1%
 
3960461< 0.1%
 
3960451< 0.1%
 
8339051< 0.1%
 
5967841< 0.1%
 
Other values (820302)82030297.9%
 
(Missing)174542.1%
 
ValueCountFrequency (%) 
21< 0.1%
 
31< 0.1%
 
41< 0.1%
 
51< 0.1%
 
61< 0.1%
 
ValueCountFrequency (%) 
8627911< 0.1%
 
8627891< 0.1%
 
8627821< 0.1%
 
8627801< 0.1%
 
8627791< 0.1%
 

CMRC_VEH_I
Boolean

MISSING

Distinct count2
Unique (%)< 0.1%
Missing822260
Missing (%)98.1%
Memory size6.4 MiB
Y
 
10472
N
 
5034
(Missing)
822260
ValueCountFrequency (%) 
Y104721.2%
 
N50340.6%
 
(Missing)82226098.1%
 

MAKE
Categorical

HIGH CARDINALITY
MISSING

Distinct count909
Unique (%)0.1%
Missing17485
Missing (%)2.1%
Memory size6.4 MiB
CHEVROLET
96438
TOYOTA MOTOR COMPANY, LTD.
87868
FORD
81836
UNKNOWN
 
80394
NISSAN
 
67980
Other values (904)
405765
ValueCountFrequency (%) 
CHEVROLET9643811.5%
 
TOYOTA MOTOR COMPANY, LTD.8786810.5%
 
FORD818369.8%
 
UNKNOWN803949.6%
 
NISSAN679808.1%
 
HONDA587567.0%
 
DODGE376434.5%
 
HYUNDAI338044.0%
 
JEEP309753.7%
 
KIA MOTORS CORP172792.1%
 
Other values (899)22730827.1%
 
(Missing)174852.1%
 

Length

Max length60
Median length7
Mean length9.355866674
Min length2

MODEL
Categorical

HIGH CARDINALITY
MISSING

Distinct count2143
Unique (%)0.3%
Missing19418
Missing (%)2.3%
Memory size6.4 MiB
UNKNOWN
177577
CAMRY
 
28533
NISSAN ALTIMA
 
17478
COROLLA
 
16570
CIVIC
 
15808
Other values (2138)
562382
ValueCountFrequency (%) 
UNKNOWN17757721.2%
 
CAMRY285333.4%
 
NISSAN ALTIMA174782.1%
 
COROLLA165702.0%
 
CIVIC158081.9%
 
ACCORD145301.7%
 
MALIBU (CHEVELLE)142061.7%
 
IMPALA127231.5%
 
SENTRA (DATSUN AND NISSAN HAVE MERGED)109251.3%
 
ELANTRA95671.1%
 
Other values (2133)50043159.7%
 
(Missing)194182.3%
 

Length

Max length60
Median length7
Mean length8.802459159
Min length2

LIC_PLATE_STATE
Categorical

HIGH CARDINALITY
MISSING

Distinct count52
Unique (%)< 0.1%
Missing84715
Missing (%)10.1%
Memory size6.4 MiB
IL
686212
XX
 
23167
IN
 
13947
WI
 
4568
MI
 
3335
Other values (47)
 
21822
ValueCountFrequency (%) 
IL68621281.9%
 
XX231672.8%
 
IN139471.7%
 
WI45680.5%
 
MI33350.4%
 
FL19340.2%
 
TX19000.2%
 
OH18420.2%
 
AZ15820.2%
 
IA13430.2%
 
Other values (42)132211.6%
 
(Missing)8471510.1%
 

Length

Max length3
Median length2
Mean length2.101120122
Min length2

VEHICLE_YEAR
Real number (ℝ≥0)

MISSING
SKEWED

Distinct count169
Unique (%)< 0.1%
Missing148417
Missing (%)17.7%
Infinite0
Infinite (%)0.0%
Mean2013.4487886397167
Minimum1900.0
Maximum9999.0
Zeros0
Zeros (%)0.0%
Memory size6.4 MiB

Quantile statistics

Minimum1900
5-th percentile1999
Q12006
median2011
Q32015
95-th percentile2018
Maximum9999
Range8099
Interquartile range (IQR)9

Descriptive statistics

Standard deviation160.9657609
Coefficient of variation (CV)0.07994529675
Kurtosis2421.532809
Mean2013.448789
Median Absolute Deviation (MAD)4
Skewness49.02841634
Sum1387968909
Variance25909.97618
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
2015565906.8%
 
2016518136.2%
 
2014504766.0%
 
2013460135.5%
 
2017457185.5%
 
2012397994.8%
 
2007358334.3%
 
2008341734.1%
 
2011331974.0%
 
2006322133.8%
 
Other values (159)26352431.5%
 
(Missing)14841717.7%
 
ValueCountFrequency (%) 
1900169< 0.1%
 
190111< 0.1%
 
19051< 0.1%
 
19111< 0.1%
 
19201< 0.1%
 
ValueCountFrequency (%) 
9999274< 0.1%
 
99001< 0.1%
 
79991< 0.1%
 
70071< 0.1%
 
64142< 0.1%
 

VEHICLE_DEFECT
Categorical

MISSING

Distinct count17
Unique (%)< 0.1%
Missing17454
Missing (%)2.1%
Memory size6.4 MiB
NONE
488521
UNKNOWN
323473
OTHER
 
4124
BRAKES
 
2754
TIRES
 
382
Other values (12)
 
1058
ValueCountFrequency (%) 
NONE48852158.3%
 
UNKNOWN32347338.6%
 
OTHER41240.5%
 
BRAKES27540.3%
 
TIRES382< 0.1%
 
STEERING340< 0.1%
 
WHEELS204< 0.1%
 
SUSPENSION117< 0.1%
 
ENGINE/MOTOR100< 0.1%
 
FUEL SYSTEM97< 0.1%
 
Other values (7)200< 0.1%
 
(Missing)174542.1%
 

Length

Max length16
Median length4
Mean length5.155025389
Min length3

VEHICLE_TYPE
Categorical

MISSING

Distinct count22
Unique (%)< 0.1%
Missing17454
Missing (%)2.1%
Memory size6.4 MiB
PASSENGER
520253
SPORT UTILITY VEHICLE (SUV)
105952
UNKNOWN/NA
 
77127
VAN/MINI-VAN
 
42940
PICKUP
 
23834
Other values (17)
 
50206
ValueCountFrequency (%) 
PASSENGER52025362.1%
 
SPORT UTILITY VEHICLE (SUV)10595212.6%
 
UNKNOWN/NA771279.2%
 
VAN/MINI-VAN429405.1%
 
PICKUP238342.8%
 
TRUCK - SINGLE UNIT160521.9%
 
BUS OVER 15 PASS.94741.1%
 
OTHER92021.1%
 
TRACTOR W/ SEMI-TRAILER79510.9%
 
MOTORCYCLE (OVER 150CC)17420.2%
 
Other values (12)57850.7%
 
(Missing)174542.1%
 

Length

Max length38
Median length9
Mean length11.79868006
Min length3

VEHICLE_USE
Categorical

MISSING

Distinct count25
Unique (%)< 0.1%
Missing17454
Missing (%)2.1%
Memory size6.4 MiB
PERSONAL
533170
UNKNOWN/NA
156172
NOT IN USE
 
39870
OTHER
 
25390
TAXI/FOR HIRE
 
15908
Other values (20)
 
49802
ValueCountFrequency (%) 
PERSONAL53317063.6%
 
UNKNOWN/NA15617218.6%
 
NOT IN USE398704.8%
 
OTHER253903.0%
 
TAXI/FOR HIRE159081.9%
 
COMMERCIAL - SINGLE UNIT108411.3%
 
RIDESHARE SERVICE83121.0%
 
CTA54960.7%
 
POLICE53380.6%
 
OTHER TRANSIT39370.5%
 
Other values (15)158781.9%
 
(Missing)174542.1%
 

Length

Max length28
Median length8
Mean length8.805004023
Min length3

TRAVEL_DIRECTION
Categorical

MISSING

Distinct count9
Unique (%)< 0.1%
Missing17454
Missing (%)2.1%
Memory size6.4 MiB
N
193869
S
187982
W
171319
E
167737
UNKNOWN
63857
Other values (4)
 
35548
ValueCountFrequency (%) 
N19386923.1%
 
S18798222.4%
 
W17131920.4%
 
E16773720.0%
 
UNKNOWN638577.6%
 
SE104191.2%
 
NW94611.1%
 
SW78460.9%
 
NE78220.9%
 
(Missing)174542.1%
 

Length

Max length7
Median length1
Mean length1.541437585
Min length1

MANEUVER
Categorical

MISSING

Distinct count28
Unique (%)< 0.1%
Missing17454
Missing (%)2.1%
Memory size6.4 MiB
STRAIGHT AHEAD
370161
PARKED
106848
SLOW/STOP IN TRAFFIC
 
66598
UNKNOWN/NA
 
62754
TURNING LEFT
 
47399
Other values (23)
166552
ValueCountFrequency (%) 
STRAIGHT AHEAD37016144.2%
 
PARKED10684812.8%
 
SLOW/STOP IN TRAFFIC665987.9%
 
UNKNOWN/NA627547.5%
 
TURNING LEFT473995.7%
 
BACKING358644.3%
 
TURNING RIGHT275763.3%
 
PASSING/OVERTAKING197102.4%
 
CHANGING LANES174812.1%
 
OTHER135821.6%
 
Other values (18)523396.2%
 
(Missing)174542.1%
 

Length

Max length34
Median length14
Mean length12.88169608
Min length3

TOWED_I
Boolean

MISSING

Distinct count2
Unique (%)< 0.1%
Missing749549
Missing (%)89.5%
Memory size6.4 MiB
Y
 
82735
N
 
5482
(Missing)
749549
ValueCountFrequency (%) 
Y827359.9%
 
N54820.7%
 
(Missing)74954989.5%
 

FIRE_I
Boolean

MISSING

Distinct count2
Unique (%)0.4%
Missing837249
Missing (%)99.9%
Memory size6.4 MiB
Y
 
287
N
 
230
(Missing)
837249
ValueCountFrequency (%) 
Y287< 0.1%
 
N230< 0.1%
 
(Missing)83724999.9%
 

OCCUPANT_CNT
Real number (ℝ≥0)

HIGH CORRELATION
MISSING
ZEROS

Distinct count42
Unique (%)< 0.1%
Missing17454
Missing (%)2.1%
Infinite0
Infinite (%)0.0%
Mean1.0935912189508383
Minimum0.0
Maximum60.0
Zeros102317
Zeros (%)12.2%
Memory size6.4 MiB

Quantile statistics

Minimum0
5-th percentile0
Q11
median1
Q31
95-th percentile2
Maximum60
Range60
Interquartile range (IQR)0

Descriptive statistics

Standard deviation0.7918176361
Coefficient of variation (CV)0.7240526647
Kurtosis211.9485143
Mean1.093591219
Median Absolute Deviation (MAD)0
Skewness6.606486737
Sum897086
Variance0.6269751689
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
159807871.4%
 
010231712.2%
 
28357410.0%
 
3227502.7%
 
490991.1%
 
529750.4%
 
67890.1%
 
7304< 0.1%
 
8123< 0.1%
 
968< 0.1%
 
Other values (32)235< 0.1%
 
(Missing)174542.1%
 
ValueCountFrequency (%) 
010231712.2%
 
159807871.4%
 
28357410.0%
 
3227502.7%
 
490991.1%
 
ValueCountFrequency (%) 
601< 0.1%
 
471< 0.1%
 
442< 0.1%
 
431< 0.1%
 
412< 0.1%
 

EXCEED_SPEED_LIMIT_I
Boolean

MISSING

Distinct count2
Unique (%)0.1%
Missing835407
Missing (%)99.7%
Memory size6.4 MiB
Y
 
1774
N
 
585
(Missing)
835407
ValueCountFrequency (%) 
Y17740.2%
 
N5850.1%
 
(Missing)83540799.7%
 

TOWED_BY
Categorical

HIGH CARDINALITY
MISSING

Distinct count7298
Unique (%)11.4%
Missing773923
Missing (%)92.4%
Memory size6.4 MiB
PRIVATE TOW
 
4849
PRIVATE
 
4847
private
 
3908
CITY OF CHICAGO
 
3828
UNKNOWN
 
3532
Other values (7293)
42879
ValueCountFrequency (%) 
PRIVATE TOW48490.6%
 
PRIVATE48470.6%
 
private39080.5%
 
CITY OF CHICAGO38280.5%
 
UNKNOWN35320.4%
 
private tow29090.3%
 
city of chicago23390.3%
 
UNK20950.3%
 
unk20760.2%
 
OWNER17610.2%
 
Other values (7288)316993.8%
 
(Missing)77392392.4%
 

Length

Max length30
Median length3
Mean length3.563915222
Min length1

TOWED_TO
Categorical

HIGH CARDINALITY
MISSING

Distinct count7702
Unique (%)19.0%
Missing797332
Missing (%)95.2%
Memory size6.4 MiB
UNKNOWN
6016
UNK
 
3568
unknown
 
3368
unk
 
2942
PRIVATE
 
633
Other values (7697)
23907
ValueCountFrequency (%) 
UNKNOWN60160.7%
 
UNK35680.4%
 
unknown33680.4%
 
unk29420.4%
 
PRIVATE6330.1%
 
private5660.1%
 
701 N SACRAMENTO415< 0.1%
 
RESIDENCE364< 0.1%
 
POUND 2343< 0.1%
 
POUND323< 0.1%
 
Other values (7692)218962.6%
 
(Missing)79733295.2%
 

Length

Max length30
Median length3
Mean length3.312754397
Min length1

AREA_00_I
Boolean

MISSING

Distinct count2
Unique (%)< 0.1%
Missing803547
Missing (%)95.9%
Memory size6.4 MiB
Y
 
29505
N
 
4714
(Missing)
803547
ValueCountFrequency (%) 
Y295053.5%
 
N47140.6%
 
(Missing)80354795.9%
 

AREA_01_I
Boolean

MISSING

Distinct count2
Unique (%)< 0.1%
Missing621754
Missing (%)74.2%
Memory size6.4 MiB
Y
206488
N
 
9524
(Missing)
621754
ValueCountFrequency (%) 
Y20648824.6%
 
N95241.1%
 
(Missing)62175474.2%
 

AREA_02_I
Boolean

MISSING

Distinct count2
Unique (%)< 0.1%
Missing687809
Missing (%)82.1%
Memory size6.4 MiB
Y
142604
N
 
7353
(Missing)
687809
ValueCountFrequency (%) 
Y14260417.0%
 
N73530.9%
 
(Missing)68780982.1%
 

AREA_03_I
Boolean

MISSING

Distinct count2
Unique (%)< 0.1%
Missing757701
Missing (%)90.4%
Memory size6.4 MiB
Y
 
76386
N
 
3679
(Missing)
757701
ValueCountFrequency (%) 
Y763869.1%
 
N36790.4%
 
(Missing)75770190.4%
 

AREA_04_I
Boolean

MISSING

Distinct count2
Unique (%)< 0.1%
Missing751174
Missing (%)89.7%
Memory size6.4 MiB
Y
 
82658
N
 
3934
(Missing)
751174
ValueCountFrequency (%) 
Y826589.9%
 
N39340.5%
 
(Missing)75117489.7%
 

AREA_05_I
Boolean

MISSING

Distinct count2
Unique (%)< 0.1%
Missing708242
Missing (%)84.5%
Memory size6.4 MiB
Y
 
124694
N
 
4830
(Missing)
708242
ValueCountFrequency (%) 
Y12469414.9%
 
N48300.6%
 
(Missing)70824284.5%
 

AREA_06_I
Boolean

MISSING

Distinct count2
Unique (%)< 0.1%
Missing714831
Missing (%)85.3%
Memory size6.4 MiB
Y
 
117730
N
 
5205
(Missing)
714831
ValueCountFrequency (%) 
Y11773014.1%
 
N52050.6%
 
(Missing)71483185.3%
 

AREA_07_I
Boolean

MISSING

Distinct count2
Unique (%)< 0.1%
Missing734840
Missing (%)87.7%
Memory size6.4 MiB
Y
 
98272
N
 
4654
(Missing)
734840
ValueCountFrequency (%) 
Y9827211.7%
 
N46540.6%
 
(Missing)73484087.7%
 

AREA_08_I
Boolean

MISSING

Distinct count2
Unique (%)< 0.1%
Missing686559
Missing (%)82.0%
Memory size6.4 MiB
Y
143118
N
 
8089
(Missing)
686559
ValueCountFrequency (%) 
Y14311817.1%
 
N80891.0%
 
(Missing)68655982.0%
 

AREA_09_I
Boolean

MISSING

Distinct count2
Unique (%)< 0.1%
Missing812559
Missing (%)97.0%
Memory size6.4 MiB
Y
 
23758
N
 
1449
(Missing)
812559
ValueCountFrequency (%) 
Y237582.8%
 
N14490.2%
 
(Missing)81255997.0%
 

AREA_10_I
Boolean

MISSING

Distinct count2
Unique (%)< 0.1%
Missing800564
Missing (%)95.6%
Memory size6.4 MiB
Y
 
35016
N
 
2186
(Missing)
800564
ValueCountFrequency (%) 
Y350164.2%
 
N21860.3%
 
(Missing)80056495.6%
 

AREA_11_I
Boolean

MISSING

Distinct count2
Unique (%)< 0.1%
Missing763625
Missing (%)91.2%
Memory size6.4 MiB
Y
 
69167
N
 
4974
(Missing)
763625
ValueCountFrequency (%) 
Y691678.3%
 
N49740.6%
 
(Missing)76362591.2%
 

AREA_12_I
Boolean

MISSING

Distinct count2
Unique (%)< 0.1%
Missing765460
Missing (%)91.4%
Memory size6.4 MiB
Y
 
69066
N
 
3240
(Missing)
765460
ValueCountFrequency (%) 
Y690668.2%
 
N32400.4%
 
(Missing)76546091.4%
 

AREA_99_I
Boolean

MISSING

Distinct count2
Unique (%)< 0.1%
Missing751710
Missing (%)89.7%
Memory size6.4 MiB
Y
 
82705
N
 
3351
(Missing)
751710
ValueCountFrequency (%) 
Y827059.9%
 
N33510.4%
 
(Missing)75171089.7%
 

FIRST_CONTACT_POINT
Categorical

MISSING

Distinct count14
Unique (%)< 0.1%
Missing21456
Missing (%)2.6%
Memory size6.4 MiB
FRONT
144611
REAR
96199
FRONT-LEFT
83519
REAR-LEFT
79417
FRONT-RIGHT
77672
Other values (9)
334892
ValueCountFrequency (%) 
FRONT14461117.3%
 
REAR9619911.5%
 
FRONT-LEFT8351910.0%
 
REAR-LEFT794179.5%
 
FRONT-RIGHT776729.3%
 
UNKNOWN748648.9%
 
SIDE-LEFT532936.4%
 
SIDE-RIGHT531526.3%
 
OTHER528636.3%
 
REAR-RIGHT381644.6%
 
Other values (4)625567.5%
 

Length

Max length17
Median length9
Mean length7.730958287
Min length3

CMV_ID
Real number (ℝ≥0)

HIGH CORRELATION
MISSING

Distinct count9034
Unique (%)100.0%
Missing828732
Missing (%)98.9%
Infinite0
Infinite (%)0.0%
Mean5060.84868275404
Minimum1.0
Maximum10242.0
Zeros0
Zeros (%)0.0%
Memory size6.4 MiB

Quantile statistics

Minimum1
5-th percentile505.65
Q12494.25
median4994.5
Q37647.75
95-th percentile9718.35
Maximum10242
Range10241
Interquartile range (IQR)5153.5

Descriptive statistics

Standard deviation2959.400933
Coefficient of variation (CV)0.5847637656
Kurtosis-1.202361292
Mean5060.848683
Median Absolute Deviation (MAD)2574
Skewness0.03839964655
Sum45719707
Variance8758053.88
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
81901< 0.1%
 
69961< 0.1%
 
29201< 0.1%
 
32211< 0.1%
 
8051< 0.1%
 
32191< 0.1%
 
32181< 0.1%
 
8041< 0.1%
 
32151< 0.1%
 
32231< 0.1%
 
Other values (9024)90241.1%
 
(Missing)82873298.9%
 
ValueCountFrequency (%) 
11< 0.1%
 
21< 0.1%
 
31< 0.1%
 
41< 0.1%
 
51< 0.1%
 
ValueCountFrequency (%) 
102421< 0.1%
 
102411< 0.1%
 
102401< 0.1%
 
102391< 0.1%
 
102381< 0.1%
 

USDOT_NO
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing832468
Missing (%)99.4%
Memory size6.4 MiB

CCMC_NO
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing836608
Missing (%)99.9%
Memory size6.4 MiB

ILCC_NO
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing836909
Missing (%)99.9%
Memory size6.4 MiB

COMMERCIAL_SRC
Categorical

MISSING

Distinct count4
Unique (%)0.1%
Missing831185
Missing (%)99.2%
Memory size6.4 MiB
SIDE OF TRUCK
2768
DRIVER
2361
PAPERS
972
LOG BOOK
 
480
ValueCountFrequency (%) 
SIDE OF TRUCK27680.3%
 
DRIVER23610.3%
 
PAPERS9720.1%
 
LOG BOOK4800.1%
 
(Missing)83118599.2%
 

Length

Max length13
Median length3
Mean length3.047840328
Min length3

GVWR
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing832521
Missing (%)99.4%
Memory size6.4 MiB

CARRIER_NAME
Categorical

HIGH CARDINALITY
MISSING

Distinct count5945
Unique (%)68.6%
Missing829095
Missing (%)99.0%
Memory size6.4 MiB
CHICAGO TRANSIT AUTHORITY
 
309
CTA
 
189
UNKNOWN
 
103
JB HUNT
 
93
CITY OF CHICAGO
 
65
Other values (5940)
7912
ValueCountFrequency (%) 
CHICAGO TRANSIT AUTHORITY309< 0.1%
 
CTA189< 0.1%
 
UNKNOWN103< 0.1%
 
JB HUNT93< 0.1%
 
CITY OF CHICAGO65< 0.1%
 
UNK46< 0.1%
 
JB HUNT TRANSPORT INC40< 0.1%
 
PACE35< 0.1%
 
PACE SUBURBAN BUS DIVISION33< 0.1%
 
PENSKE TRUCK LEASING30< 0.1%
 
Other values (5935)77280.9%
 
(Missing)82909599.0%
 

Length

Max length55
Median length3
Mean length3.168847864
Min length2

CARRIER_STATE
Categorical

MISSING

Distinct count47
Unique (%)0.6%
Missing829541
Missing (%)99.0%
Memory size6.4 MiB
IL
5191
IN
 
699
WI
 
276
TX
 
157
MI
 
154
Other values (42)
1748
ValueCountFrequency (%) 
IL51910.6%
 
IN6990.1%
 
WI276< 0.1%
 
TX157< 0.1%
 
MI154< 0.1%
 
OH139< 0.1%
 
IA132< 0.1%
 
PA117< 0.1%
 
AZ106< 0.1%
 
MN104< 0.1%
 
Other values (37)11500.1%
 
(Missing)82954199.0%
 

Length

Max length3
Median length3
Mean length2.990182223
Min length2

CARRIER_CITY
Categorical

HIGH CARDINALITY
MISSING

Distinct count1443
Unique (%)17.9%
Missing829690
Missing (%)99.0%
Memory size6.4 MiB
CHICAGO
2095
GARY
 
121
LOWELL
 
93
INDIANAPOLIS
 
88
NOBLESVILLE
 
86
Other values (1438)
5593
ValueCountFrequency (%) 
CHICAGO20950.3%
 
GARY121< 0.1%
 
LOWELL93< 0.1%
 
INDIANAPOLIS88< 0.1%
 
NOBLESVILLE86< 0.1%
 
ARLINGTON HEIGHTS84< 0.1%
 
CICERO78< 0.1%
 
SKOKIE77< 0.1%
 
DES PLAINES77< 0.1%
 
ADDISON72< 0.1%
 
Other values (1433)52050.6%
 
(Missing)82969099.0%
 

Length

Max length26
Median length3
Mean length3.053433775
Min length1

HAZMAT_PLACARDS_I
Boolean

MISSING

Distinct count2
Unique (%)1.1%
Missing837586
Missing (%)> 99.9%
Memory size6.4 MiB
N
 
120
Y
 
60
(Missing)
837586
ValueCountFrequency (%) 
N120< 0.1%
 
Y60< 0.1%
 
(Missing)837586> 99.9%
 

HAZMAT_NAME
Categorical

MISSING

Distinct count24
Unique (%)72.7%
Missing837733
Missing (%)> 99.9%
Memory size6.4 MiB
CORROSIVE
 
3
FLAMMABLE
 
3
PROPANE
 
3
FLAMMABLE LIQUID
 
2
GASOLINE
 
2
Other values (19)
20
ValueCountFrequency (%) 
CORROSIVE3< 0.1%
 
FLAMMABLE3< 0.1%
 
PROPANE3< 0.1%
 
FLAMMABLE LIQUID2< 0.1%
 
GASOLINE2< 0.1%
 
OXIDIZER2< 0.1%
 
INTEGRAL SLEEPER1< 0.1%
 
OXYGEN LIQUID1< 0.1%
 
FUEL OIL1< 0.1%
 
FLAME1< 0.1%
 
Other values (14)14< 0.1%
 
(Missing)837733> 99.9%
 

Length

Max length20
Median length3
Mean length3.000284089
Min length1

UN_NO
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing837430
Missing (%)> 99.9%
Memory size6.4 MiB

HAZMAT_PRESENT_I
Categorical

MISSING

Distinct count3
Unique (%)< 0.1%
Missing831130
Missing (%)99.2%
Memory size6.4 MiB
N
6223
U
 
400
Y
 
13
ValueCountFrequency (%) 
N62230.7%
 
U400< 0.1%
 
Y13< 0.1%
 
(Missing)83113099.2%
 

Length

Max length3
Median length3
Mean length2.984157867
Min length1

HAZMAT_REPORT_I
Categorical

MISSING

Distinct count3
Unique (%)< 0.1%
Missing831337
Missing (%)99.2%
Memory size6.4 MiB
N
5610
U
 
811
Y
 
8
ValueCountFrequency (%) 
N56100.7%
 
U8110.1%
 
Y8< 0.1%
 
(Missing)83133799.2%
 

Length

Max length3
Median length3
Mean length2.984652039
Min length1

HAZMAT_REPORT_NO
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing837766
Missing (%)100.0%
Memory size6.4 MiB

MCS_REPORT_I
Categorical

MISSING

Distinct count3
Unique (%)< 0.1%
Missing831288
Missing (%)99.2%
Memory size6.4 MiB
N
5196
U
1274
Y
 
8
ValueCountFrequency (%) 
N51960.6%
 
U12740.2%
 
Y8< 0.1%
 
(Missing)83128899.2%
 

Length

Max length3
Median length3
Mean length2.984535061
Min length1

MCS_REPORT_NO
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing837761
Missing (%)> 99.9%
Memory size6.4 MiB

HAZMAT_VIO_CAUSE_CRASH_I
Categorical

MISSING

Distinct count3
Unique (%)< 0.1%
Missing831236
Missing (%)99.2%
Memory size6.4 MiB
N
6039
U
 
484
Y
 
7
ValueCountFrequency (%) 
N60390.7%
 
U4840.1%
 
Y7< 0.1%
 
(Missing)83123699.2%
 

Length

Max length3
Median length3
Mean length2.984410921
Min length1

MCS_VIO_CAUSE_CRASH_I
Categorical

MISSING

Distinct count3
Unique (%)< 0.1%
Missing831330
Missing (%)99.2%
Memory size6.4 MiB
N
5410
U
 
1013
Y
 
13
ValueCountFrequency (%) 
N54100.6%
 
U10130.1%
 
Y13< 0.1%
 
(Missing)83133099.2%
 

Length

Max length3
Median length3
Mean length2.984635328
Min length1

IDOT_PERMIT_NO
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing837227
Missing (%)99.9%
Memory size6.4 MiB

WIDE_LOAD_I
Boolean

MISSING

Distinct count2
Unique (%)2.7%
Missing837692
Missing (%)> 99.9%
Memory size6.4 MiB
Y
 
46
N
 
28
(Missing)
837692
ValueCountFrequency (%) 
Y46< 0.1%
 
N28< 0.1%
 
(Missing)837692> 99.9%
 

TRAILER1_WIDTH
Categorical

MISSING

Distinct count3
Unique (%)0.2%
Missing835808
Missing (%)99.8%
Memory size6.4 MiB
0-96
1299
97-102
397
>102
262
ValueCountFrequency (%) 
0-9612990.2%
 
97-102397< 0.1%
 
>102262< 0.1%
 
(Missing)83580899.8%
 

Length

Max length6
Median length3
Mean length3.003284927
Min length3

TRAILER2_WIDTH
Categorical

MISSING

Distinct count3
Unique (%)1.4%
Missing837544
Missing (%)> 99.9%
Memory size6.4 MiB
0-96
138
>102
46
97-102
38
ValueCountFrequency (%) 
0-96138< 0.1%
 
>10246< 0.1%
 
97-10238< 0.1%
 
(Missing)837544> 99.9%
 

Length

Max length6
Median length3
Mean length3.000355708
Min length3

TRAILER1_LENGTH
Real number (ℝ≥0)

MISSING

Distinct count76
Unique (%)4.7%
Missing836152
Missing (%)99.8%
Infinite0
Infinite (%)0.0%
Mean47.84634448574969
Minimum1.0
Maximum200.0
Zeros0
Zeros (%)0.0%
Memory size6.4 MiB

Quantile statistics

Minimum1
5-th percentile20
Q140.25
median53
Q353
95-th percentile60
Maximum200
Range199
Interquartile range (IQR)12.75

Descriptive statistics

Standard deviation16.00437582
Coefficient of variation (CV)0.3344952681
Kurtosis8.200729415
Mean47.84634449
Median Absolute Deviation (MAD)0
Skewness0.835641432
Sum77224
Variance256.1400455
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
538650.1%
 
4895< 0.1%
 
4090< 0.1%
 
3052< 0.1%
 
2040< 0.1%
 
5036< 0.1%
 
5232< 0.1%
 
4526< 0.1%
 
2823< 0.1%
 
2523< 0.1%
 
Other values (66)332< 0.1%
 
(Missing)83615299.8%
 
ValueCountFrequency (%) 
16< 0.1%
 
41< 0.1%
 
66< 0.1%
 
71< 0.1%
 
82< 0.1%
 
ValueCountFrequency (%) 
2001< 0.1%
 
1251< 0.1%
 
1203< 0.1%
 
1154< 0.1%
 
1141< 0.1%
 

TRAILER2_LENGTH
Real number (ℝ≥0)

MISSING

Distinct count28
Unique (%)62.2%
Missing837721
Missing (%)> 99.9%
Infinite0
Infinite (%)0.0%
Mean43.888888888888886
Minimum2.0
Maximum120.0
Zeros0
Zeros (%)0.0%
Memory size6.4 MiB

Quantile statistics

Minimum2
5-th percentile8.4
Q124
median45
Q353
95-th percentile96
Maximum120
Range118
Interquartile range (IQR)29

Descriptive statistics

Standard deviation28.544401
Coefficient of variation (CV)0.6503787569
Kurtosis0.1429226276
Mean43.88888889
Median Absolute Deviation (MAD)18
Skewness0.7334259495
Sum1975
Variance814.7828283
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
539< 0.1%
 
253< 0.1%
 
963< 0.1%
 
482< 0.1%
 
122< 0.1%
 
602< 0.1%
 
142< 0.1%
 
402< 0.1%
 
501< 0.1%
 
431< 0.1%
 
Other values (18)18< 0.1%
 
(Missing)837721> 99.9%
 
ValueCountFrequency (%) 
21< 0.1%
 
31< 0.1%
 
81< 0.1%
 
101< 0.1%
 
122< 0.1%
 
ValueCountFrequency (%) 
1201< 0.1%
 
991< 0.1%
 
963< 0.1%
 
901< 0.1%
 
731< 0.1%
 

TOTAL_VEHICLE_LENGTH
Real number (ℝ≥0)

MISSING

Distinct count109
Unique (%)5.6%
Missing835813
Missing (%)99.8%
Infinite0
Infinite (%)0.0%
Mean52.26011264720942
Minimum1.0
Maximum535.0
Zeros0
Zeros (%)0.0%
Memory size6.4 MiB

Quantile statistics

Minimum1
5-th percentile17
Q132
median53
Q365
95-th percentile80
Maximum535
Range534
Interquartile range (IQR)33

Descriptive statistics

Standard deviation26.97302332
Coefficient of variation (CV)0.5161302178
Kurtosis61.01328285
Mean52.26011265
Median Absolute Deviation (MAD)15
Skewness4.306772191
Sum102064
Variance727.5439871
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
65182< 0.1%
 
53161< 0.1%
 
40137< 0.1%
 
75122< 0.1%
 
60109< 0.1%
 
6397< 0.1%
 
7091< 0.1%
 
3075< 0.1%
 
2074< 0.1%
 
6867< 0.1%
 
Other values (99)8380.1%
 
(Missing)83581399.8%
 
ValueCountFrequency (%) 
12< 0.1%
 
41< 0.1%
 
51< 0.1%
 
64< 0.1%
 
72< 0.1%
 
ValueCountFrequency (%) 
5351< 0.1%
 
3051< 0.1%
 
2651< 0.1%
 
2452< 0.1%
 
1961< 0.1%
 

AXLE_CNT
Real number (ℝ≥0)

MISSING
SKEWED

Distinct count17
Unique (%)0.6%
Missing835049
Missing (%)99.7%
Infinite0
Infinite (%)0.0%
Mean13.324622745675377
Minimum1.0
Maximum26009.0
Zeros0
Zeros (%)0.0%
Memory size6.4 MiB

Quantile statistics

Minimum1
5-th percentile2
Q12
median3
Q35
95-th percentile6
Maximum26009
Range26008
Interquartile range (IQR)3

Descriptive statistics

Standard deviation498.9121958
Coefficient of variation (CV)37.44287589
Kurtosis2716.800551
Mean13.32462275
Median Absolute Deviation (MAD)1
Skewness52.12198557
Sum36203
Variance248913.3791
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
58480.1%
 
28340.1%
 
36200.1%
 
6206< 0.1%
 
4133< 0.1%
 
133< 0.1%
 
815< 0.1%
 
710< 0.1%
 
185< 0.1%
 
164< 0.1%
 
Other values (7)9< 0.1%
 
(Missing)83504999.7%
 
ValueCountFrequency (%) 
133< 0.1%
 
28340.1%
 
36200.1%
 
4133< 0.1%
 
58480.1%
 
ValueCountFrequency (%) 
260091< 0.1%
 
991< 0.1%
 
771< 0.1%
 
551< 0.1%
 
185< 0.1%
 

VEHICLE_CONFIG
Categorical

MISSING

Distinct count8
Unique (%)0.1%
Missing830224
Missing (%)99.1%
Memory size6.4 MiB
TRACTOR/SEMI-TRAILER
2910
SINGLE UNIT TRUCK, 2 AXLES, 6 TIRES
1504
BUS
1257
TRUCK/TRACTOR
622
TRUCK/TRAILER
 
506
Other values (3)
743
ValueCountFrequency (%) 
TRACTOR/SEMI-TRAILER29100.3%
 
SINGLE UNIT TRUCK, 2 AXLES, 6 TIRES15040.2%
 
BUS12570.2%
 
TRUCK/TRACTOR6220.1%
 
TRUCK/TRAILER5060.1%
 
UNKNOWN HEAVY TRUCK394< 0.1%
 
SINGLE UNIT TRUCK, 3 OR MORE AXLES328< 0.1%
 
TRACTOR/DOUBLES21< 0.1%
 
(Missing)83022499.1%
 

Length

Max length35
Median length3
Mean length3.149924919
Min length3

CARGO_BODY_TYPE
Categorical

MISSING

Distinct count9
Unique (%)0.1%
Missing830540
Missing (%)99.1%
Memory size6.4 MiB
VAN/ENCLOSED BOX
3189
OTHER
1546
BUS
1214
FLATBED
 
549
DUMP
 
267
Other values (4)
 
461
ValueCountFrequency (%) 
VAN/ENCLOSED BOX31890.4%
 
OTHER15460.2%
 
BUS12140.1%
 
FLATBED5490.1%
 
DUMP267< 0.1%
 
GARBAGE/REFUSE178< 0.1%
 
TANK146< 0.1%
 
AUTO TRANSPORTER70< 0.1%
 
CONCRETE MIXER67< 0.1%
 
(Missing)83054099.1%
 

Length

Max length16
Median length3
Mean length3.060593292
Min length3

LOAD_TYPE
Categorical

MISSING

Distinct count6
Unique (%)0.1%
Missing830854
Missing (%)99.2%
Memory size6.4 MiB
OTHER
3957
UNKNOWN
2529
CONSTRUCTION EQUIPMENT
 
238
BUILDING MATERIALS
 
144
STEEL COILS
 
34
ValueCountFrequency (%) 
OTHER39570.5%
 
UNKNOWN25290.3%
 
CONSTRUCTION EQUIPMENT238< 0.1%
 
BUILDING MATERIALS144< 0.1%
 
STEEL COILS34< 0.1%
 
FARM EQUIPMENT10< 0.1%
 
(Missing)83085499.2%
 

Length

Max length22
Median length3
Mean length3.029953471
Min length3
Distinct count2
Unique (%)< 0.1%
Missing831529
Missing (%)99.3%
Memory size6.4 MiB
N
 
6228
Y
 
9
(Missing)
831529
ValueCountFrequency (%) 
N62280.7%
 
Y9< 0.1%
 
(Missing)83152999.3%
 

MCS_OUT_OF_SERVICE_I
Boolean

MISSING

Distinct count2
Unique (%)< 0.1%
Missing831353
Missing (%)99.2%
Memory size6.4 MiB
N
 
6381
Y
 
32
(Missing)
831353
ValueCountFrequency (%) 
N63810.8%
 
Y32< 0.1%
 
(Missing)83135399.2%
 

HAZMAT_CLASS
Categorical

MISSING

Distinct count8
Unique (%)1.3%
Missing837151
Missing (%)99.9%
Memory size6.4 MiB
MISCELLANEOUS
527
FLAMMABLE OR COMBUSTIBLE LIQUID
 
40
GASES
 
16
EXPLOSIVES
 
16
CORROSIVE
 
11
Other values (3)
 
5
ValueCountFrequency (%) 
MISCELLANEOUS5270.1%
 
FLAMMABLE OR COMBUSTIBLE LIQUID40< 0.1%
 
GASES16< 0.1%
 
EXPLOSIVES16< 0.1%
 
CORROSIVE11< 0.1%
 
FLAMMABLE SOLID, SPONTANEOUSLY COMBUSTIBLE, OR DANGEROUS WHEN WET2< 0.1%
 
OXIDIZER OR ORGANIC PEROXIDE2< 0.1%
 
POISON (TOXIC) OR POISON INHALATION HAZARD1< 0.1%
 
(Missing)83715199.9%
 

Length

Max length65
Median length3
Mean length3.008132342
Min length3

Interactions

Correlations

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Missing values

Sample

First rows

CRASH_UNIT_IDCRASH_RECORD_IDRD_NOCRASH_DATEUNIT_NOUNIT_TYPENUM_PASSENGERSVEHICLE_IDCMRC_VEH_IMAKEMODELLIC_PLATE_STATEVEHICLE_YEARVEHICLE_DEFECTVEHICLE_TYPEVEHICLE_USETRAVEL_DIRECTIONMANEUVERTOWED_IFIRE_IOCCUPANT_CNTEXCEED_SPEED_LIMIT_ITOWED_BYTOWED_TOAREA_00_IAREA_01_IAREA_02_IAREA_03_IAREA_04_IAREA_05_IAREA_06_IAREA_07_IAREA_08_IAREA_09_IAREA_10_IAREA_11_IAREA_12_IAREA_99_IFIRST_CONTACT_POINTCMV_IDUSDOT_NOCCMC_NOILCC_NOCOMMERCIAL_SRCGVWRCARRIER_NAMECARRIER_STATECARRIER_CITYHAZMAT_PLACARDS_IHAZMAT_NAMEUN_NOHAZMAT_PRESENT_IHAZMAT_REPORT_IHAZMAT_REPORT_NOMCS_REPORT_IMCS_REPORT_NOHAZMAT_VIO_CAUSE_CRASH_IMCS_VIO_CAUSE_CRASH_IIDOT_PERMIT_NOWIDE_LOAD_ITRAILER1_WIDTHTRAILER2_WIDTHTRAILER1_LENGTHTRAILER2_LENGTHTOTAL_VEHICLE_LENGTHAXLE_CNTVEHICLE_CONFIGCARGO_BODY_TYPELOAD_TYPEHAZMAT_OUT_OF_SERVICE_IMCS_OUT_OF_SERVICE_IHAZMAT_CLASS
0102e31858c0e411f0bdcb337fb7c415aa93763cf2f23e02fb278e2ed4cf855d36c5a83f270e6f2e0e234ec48b4a0e55a2c51e37b0d40677392c25079c51727a57fHY36870808/04/2015 12:40:00 PM1DRIVERNaN10.0NaNFORDFocusIL2001.0NONEPASSENGERPERSONALNTURNING LEFTNaNNaN1.0NaNNaNNaNNYYNaNNaNNaNNaNNaNYNaNNaNNaNNaNNaNFRONTNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
1100e73b35bd7651b0c6693162bee0666db159b2890143700936741e9ad9cfc1b0d7f71c0f63dc0594ecdd6fd2183fa2dcd67dfa76a4799839a00a81bc45e3966bb1HY37401807/31/2015 05:50:00 PM1DRIVERNaN96.0NaNNISSANPathfinderIL1999.0NONESPORT UTILITY VEHICLE (SUV)PERSONALESTRAIGHT AHEADNaNNaN1.0NaNNaNNaNNaNYNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNFRONTNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
21000f2b1adeb85a15112e4fb7db74bff440d6ca53ff7a21e10490081685db85460a53c0f3d52dc0e181e69348053ef3198dccbc24e01df9179e42331bc4345e6f28dHY40743109/02/2015 11:45:00 AM1DRIVERNaN954.0NaNFORDF150KSNaNUNKNOWNVAN/MINI-VANUNKNOWN/NAWSTRAIGHT AHEADNaNNaN1.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNYFRONTNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
31000015a3e24fce3ce7cd2b02d44013d1a93ff2fbdca80632ecca87150673b21e819bd8649e309f867728fd25a9a9fcb6f0f2c00c42ab6733e4d6945262dbe6c90c0eHY48414810/31/2015 09:30:00 PM2DRIVERNaN9561.0NaNHYUNDAISONATANaN2011.0NONEPASSENGERPERSONALESLOW/STOP IN TRAFFICNaNNaN1.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNREARNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
41000001d3c178880366c77deaf06b8c3198429112a1c8e8807ed95cea7b44e891a873df5b99852206a32d25fe2ede813c2149f25a43b7d2d3e1cc24b62fa437abd638fHZ51893411/16/2016 01:00:00 PM2PARKEDNaN96745.0NaNTOYOTA MOTOR COMPANY, LTD.RAV4 (sport utility)IL2001.0UNKNOWNSPORT UTILITY VEHICLE (SUV)NOT IN USESPARKEDNaNNaN0.0NaNNaNNaNNYNaNNaNNaNYNaNNaNNaNNaNNaNNaNNaNNaNUNKNOWNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
51000012fcefeab458932d8b1b12e103c18c50adc659943cccd4b17fc22124a16b1ba9df582f703cd07e7ba892d00b904c9a9849b7c0b6a39063c00e829a752fe22f206HZ52561911/15/2016 05:45:00 PM1DRIVERNaN96762.0NaNUNKNOWNUNKNOWNNaNNaNUNKNOWNUNKNOWN/NAUNKNOWN/NAUNKNOWNUNKNOWN/NANaNNaN1.0NaNNaNNaNNaNNaNNaNNaNNaNNaNYYYNaNNaNNaNNaNNaNSIDE-LEFTNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
61000022fcefeab458932d8b1b12e103c18c50adc659943cccd4b17fc22124a16b1ba9df582f703cd07e7ba892d00b904c9a9849b7c0b6a39063c00e829a752fe22f206HZ52561911/15/2016 05:45:00 PM2DRIVERNaN96754.0NaNDODGECARAVANIL2012.0NONEPASSENGERPERSONALESTRAIGHT AHEADNaNNaN1.0NaNNaNNaNNaNNaNYYYNaNNaNNaNNaNNaNNaNNaNNaNNaNSIDE-LEFTNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
7100003c2f21fd14725cf30d43ae59057e59b2e225c9e62a846e7995a6fbf041a23f4578ac02ec12570a1451580b566e134a1aeccceabfc653a1b9a8ca87d122d2bd3e8HZ52562911/22/2016 01:45:00 PM1DRIVERNaN96757.0NaNNISSANUNKNOWNIL2006.0NONEPASSENGERPERSONALNSTRAIGHT AHEADNaNNaN1.0NaNNaNNaNNaNYNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNFRONTNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
8100004c2f21fd14725cf30d43ae59057e59b2e225c9e62a846e7995a6fbf041a23f4578ac02ec12570a1451580b566e134a1aeccceabfc653a1b9a8ca87d122d2bd3e8HZ52562911/22/2016 01:45:00 PM2DRIVERNaN96755.0NaNTOYOTA MOTOR COMPANY, LTD.COROLLAIL2008.0NONEPASSENGERPERSONALNSLOW/STOP IN TRAFFICNaNNaN1.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNYNaNNaNNaNREARNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
91000055bfddf5ec81892bf71c2ba0f807c1ec112fd7ecdecbf3c6abbcea4314d7333fc6a4a058537ee8e97dbbb73019444b810f8aabe493003563d25736a5bd2c278a9HZ52560611/19/2016 06:35:00 PM1DRIVERNaN96759.0NaNBUICKUNKNOWNIL2012.0UNKNOWNPASSENGERPERSONALNCHANGING LANESNaNNaN1.0NaNNaNNaNNaNNaNYNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNFRONT-RIGHTNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN

Last rows

CRASH_UNIT_IDCRASH_RECORD_IDRD_NOCRASH_DATEUNIT_NOUNIT_TYPENUM_PASSENGERSVEHICLE_IDCMRC_VEH_IMAKEMODELLIC_PLATE_STATEVEHICLE_YEARVEHICLE_DEFECTVEHICLE_TYPEVEHICLE_USETRAVEL_DIRECTIONMANEUVERTOWED_IFIRE_IOCCUPANT_CNTEXCEED_SPEED_LIMIT_ITOWED_BYTOWED_TOAREA_00_IAREA_01_IAREA_02_IAREA_03_IAREA_04_IAREA_05_IAREA_06_IAREA_07_IAREA_08_IAREA_09_IAREA_10_IAREA_11_IAREA_12_IAREA_99_IFIRST_CONTACT_POINTCMV_IDUSDOT_NOCCMC_NOILCC_NOCOMMERCIAL_SRCGVWRCARRIER_NAMECARRIER_STATECARRIER_CITYHAZMAT_PLACARDS_IHAZMAT_NAMEUN_NOHAZMAT_PRESENT_IHAZMAT_REPORT_IHAZMAT_REPORT_NOMCS_REPORT_IMCS_REPORT_NOHAZMAT_VIO_CAUSE_CRASH_IMCS_VIO_CAUSE_CRASH_IIDOT_PERMIT_NOWIDE_LOAD_ITRAILER1_WIDTHTRAILER2_WIDTHTRAILER1_LENGTHTRAILER2_LENGTHTOTAL_VEHICLE_LENGTHAXLE_CNTVEHICLE_CONFIGCARGO_BODY_TYPELOAD_TYPEHAZMAT_OUT_OF_SERVICE_IMCS_OUT_OF_SERVICE_IHAZMAT_CLASS
837756903038b6b89d3e6f386c124c7bd0ca58c0979e324cd367dc4b6ae1eee837536b137dd74a5a33f4dbfa4d7bf74b54ebca72a26749a8e8967d601bbd51c0dbdcf3d4296aJD27033906/16/2020 09:25:00 PM1DRIVERNaN856268.0NaNSTERLINGOTHER (EXPLAIN IN NARRATIVE)IL2007.0UNKNOWNUNKNOWN/NAUNKNOWN/NAWSTRAIGHT AHEADNaNNaN1.0NaNNaNNaNNaNYNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNFRONTNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
837757903039b6b89d3e6f386c124c7bd0ca58c0979e324cd367dc4b6ae1eee837536b137dd74a5a33f4dbfa4d7bf74b54ebca72a26749a8e8967d601bbd51c0dbdcf3d4296aJD27033906/16/2020 09:25:00 PM2PARKED4.0856274.0NaNFORDEXPLORERIL2004.0UNKNOWNSPORT UTILITY VEHICLE (SUV)UNKNOWN/NAWPARKEDNaNNaN4.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNYNaNNaNNaNNaNNaNNaNFRONT-LEFTNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
8377589038835526a4009f96cf49b607eed87ab770599919c08bd03e3b164f738c9318cd54fffb1e3ce1d13a29a5fc5ccf3d86106ea37ece3056b98b88fcfe96db31603ec9b7JD26634306/16/2020 07:45:00 PM1DRIVERNaN857068.0NaNCHRYSLERSEBRINGIL2002.0UNKNOWNPASSENGERPERSONALEUNKNOWN/NAYNaN1.0NaNe&r103rd and dotyNaNYYNaNNaNNaNNaNNaNNaNNaNYYYNaNOTHERNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
8377599038845526a4009f96cf49b607eed87ab770599919c08bd03e3b164f738c9318cd54fffb1e3ce1d13a29a5fc5ccf3d86106ea37ece3056b98b88fcfe96db31603ec9b7JD26634306/16/2020 07:45:00 PM2DRIVERNaN857069.0NaNNISSANROGUEIL2018.0NONEPASSENGERPERSONALWOTHERNaNNaN1.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNYNaNNaNNaNNaNNaNNaNSIDE-LEFTNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
837760904947f8789485a2c59cc21aaca437a448821a33a42b4be8de6f06f49ba6fa5feef2c01a18bcbf4ccc2d811d77c4867f8d00ec3678f70295f311a696840131f580c115JD27362706/16/2020 02:00:00 PM1DRIVERNaN858084.0YFREIGHTLINER CORPORATIONOTHER (EXPLAIN IN NARRATIVE)IL1998.0UNKNOWNTRUCK - SINGLE UNITCOMMERCIAL - SINGLE UNITETURNING RIGHTNaNNaN1.0NaNNaNNaNNaNYNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNFRONTNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
837761904948f8789485a2c59cc21aaca437a448821a33a42b4be8de6f06f49ba6fa5feef2c01a18bcbf4ccc2d811d77c4867f8d00ec3678f70295f311a696840131f580c115JD27362706/16/2020 02:00:00 PM2DRIVERNaN858089.0NaNDODGERAM 1500 PUIL2016.0NONEPICKUPOTHERETURNING RIGHTNaNNaN1.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNYNaNNaNNaNNaNROOFNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
837762905072c7da7a2778969bfebbfa528ce03c975c21412b82fd7b61e8666fd85f6d6f402cb465831ee8e19b57a7eb2fd43c030e1fc20d61d4b0ac5a2df4813aaf1a5815f4JD27356506/16/2020 12:30:00 PM1DRIVERNaN858203.0NaNCHRYSLEROTHER (EXPLAIN IN NARRATIVE)IL2007.0UNKNOWNPASSENGERPERSONALNSTRAIGHT AHEADNaNNaN1.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNYUNKNOWNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
837763905073c7da7a2778969bfebbfa528ce03c975c21412b82fd7b61e8666fd85f6d6f402cb465831ee8e19b57a7eb2fd43c030e1fc20d61d4b0ac5a2df4813aaf1a5815f4JD27356506/16/2020 12:30:00 PM2DRIVERNaN858210.0NaNFORDTAURUSIL2012.0NONEPASSENGERPERSONALNSTRAIGHT AHEADNaNNaN1.0NaNNaNNaNNaNNaNNaNNaNNaNNaNYNaNNaNNaNNaNNaNNaNNaNREAR-LEFTNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
83776490508409a93b52a5387fec43780859b3b6539431ec1e8774372dbaecd12b28601b97821b500911dc61dba23259b03d4542f843c2d292a82c6a79aa8ad60e1a1f9cffd6JD27388806/16/2020 08:30:00 AM1DRIVERNaN858212.0NaNDODGEOTHER (EXPLAIN IN NARRATIVE)IL2008.0NONEPICKUPUNKNOWN/NAUNKNOWNUNKNOWN/NANaNNaN1.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNYUNKNOWNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
83776590508509a93b52a5387fec43780859b3b6539431ec1e8774372dbaecd12b28601b97821b500911dc61dba23259b03d4542f843c2d292a82c6a79aa8ad60e1a1f9cffd6JD27388806/16/2020 08:30:00 AM2PARKEDNaN858205.0NaNHYUNDAISONATAIL2011.0NONEPASSENGERPERSONALEPARKEDNaNNaN0.0NaNNaNNaNNaNNaNNaNNaNYNNaNNaNNaNNaNYYNaNNaNFRONT-RIGHTNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN